Overview
Brought to you by YData
Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 664841 |
| Missing cells | 570417 |
| Missing cells (%) | 6.6% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 350.7 MiB |
| Average record size in memory | 553.1 B |
Variable types
| Text | 3 |
|---|---|
| Categorical | 2 |
| DateTime | 2 |
| Numeric | 6 |
end_lat is highly overall correlated with start_lat | High correlation |
end_lng is highly overall correlated with start_lng | High correlation |
start_lat is highly overall correlated with end_lat | High correlation |
start_lng is highly overall correlated with end_lng | High correlation |
start_station_name has 139752 (21.0%) missing values | Missing |
start_station_id has 139752 (21.0%) missing values | Missing |
end_station_name has 144920 (21.8%) missing values | Missing |
end_station_id has 145015 (21.8%) missing values | Missing |
end_lng is highly skewed (γ1 = 248.6115777) | Skewed |
ride_id has unique values | Unique |
Reproduction
| Analysis started | 2025-05-04 18:31:44.792445 |
|---|---|
| Analysis finished | 2025-05-04 18:32:01.403064 |
| Duration | 16.61 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
ride_id
Text
Unique 
| Distinct | 664841 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 46.3 MiB |
Length
| Max length | 16 |
|---|---|
| Median length | 16 |
| Mean length | 16 |
| Min length | 16 |
Unique
| Unique | 664841 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 9C4EFBCCA63C94D8 |
|---|---|
| 2nd row | 302DB0DF65954B5A |
| 3rd row | B8E500B89C4358DC |
| 4th row | 05771DAB5118E255 |
| 5th row | A0BAFC8706AD756F |
| Value | Count | Frequency (%) |
| 9c4efbcca63c94d8 | 1 | < 0.1% |
| f813364dde0ae483 | 1 | < 0.1% |
| 2de6b8d1a56a151c | 1 | < 0.1% |
| 98f6b617e25798bf | 1 | < 0.1% |
| 093fae32f60c1e45 | 1 | < 0.1% |
| b8e500b89c4358dc | 1 | < 0.1% |
| 05771dab5118e255 | 1 | < 0.1% |
| a0bafc8706ad756f | 1 | < 0.1% |
| 009bae9057af9068 | 1 | < 0.1% |
| f2841b741a0f3d93 | 1 | < 0.1% |
| Other values (664831) | 664831 |
Most occurring characters
| Value | Count | Frequency (%) |
| B | 666241 | 6.3% |
| 7 | 666133 | 6.3% |
| 2 | 665876 | 6.3% |
| 3 | 665582 | 6.3% |
| D | 665277 | 6.3% |
| 0 | 665219 | 6.3% |
| 1 | 665090 | 6.3% |
| A | 664611 | 6.2% |
| 9 | 664492 | 6.2% |
| C | 664491 | 6.2% |
| Other values (6) | 3984444 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 10637456 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| B | 666241 | 6.3% |
| 7 | 666133 | 6.3% |
| 2 | 665876 | 6.3% |
| 3 | 665582 | 6.3% |
| D | 665277 | 6.3% |
| 0 | 665219 | 6.3% |
| 1 | 665090 | 6.3% |
| A | 664611 | 6.2% |
| 9 | 664492 | 6.2% |
| C | 664491 | 6.2% |
| Other values (6) | 3984444 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 10637456 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| B | 666241 | 6.3% |
| 7 | 666133 | 6.3% |
| 2 | 665876 | 6.3% |
| 3 | 665582 | 6.3% |
| D | 665277 | 6.3% |
| 0 | 665219 | 6.3% |
| 1 | 665090 | 6.3% |
| A | 664611 | 6.2% |
| 9 | 664492 | 6.2% |
| C | 664491 | 6.2% |
| Other values (6) | 3984444 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 10637456 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| B | 666241 | 6.3% |
| 7 | 666133 | 6.3% |
| 2 | 665876 | 6.3% |
| 3 | 665582 | 6.3% |
| D | 665277 | 6.3% |
| 0 | 665219 | 6.3% |
| 1 | 665090 | 6.3% |
| A | 664611 | 6.2% |
| 9 | 664492 | 6.2% |
| C | 664491 | 6.2% |
| Other values (6) | 3984444 |
rideable_type
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 44.1 MiB |
| electric_bike | |
|---|---|
| classic_bike |
Length
| Max length | 13 |
|---|---|
| Median length | 13 |
| Mean length | 12.595233 |
| Min length | 12 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | classic_bike |
|---|---|
| 2nd row | classic_bike |
| 3rd row | classic_bike |
| 4th row | electric_bike |
| 5th row | electric_bike |
Common Values
| Value | Count | Frequency (%) |
| electric_bike | 395735 | |
| classic_bike | 269106 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| electric_bike | 395735 | |
| classic_bike | 269106 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 1456311 | |
| c | 1329682 | |
| i | 1329682 | |
| l | 664841 | |
| _ | 664841 | |
| b | 664841 | |
| k | 664841 | |
| s | 538212 | 6.4% |
| t | 395735 | 4.7% |
| r | 395735 | 4.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 8373827 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 1456311 | |
| c | 1329682 | |
| i | 1329682 | |
| l | 664841 | |
| _ | 664841 | |
| b | 664841 | |
| k | 664841 | |
| s | 538212 | 6.4% |
| t | 395735 | 4.7% |
| r | 395735 | 4.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 8373827 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 1456311 | |
| c | 1329682 | |
| i | 1329682 | |
| l | 664841 | |
| _ | 664841 | |
| b | 664841 | |
| k | 664841 | |
| s | 538212 | 6.4% |
| t | 395735 | 4.7% |
| r | 395735 | 4.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 8373827 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 1456311 | |
| c | 1329682 | |
| i | 1329682 | |
| l | 664841 | |
| _ | 664841 | |
| b | 664841 | |
| k | 664841 | |
| s | 538212 | 6.4% |
| t | 395735 | 4.7% |
| r | 395735 | 4.7% |
started_at
Date
| Distinct | 664697 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.1 MiB |
| Minimum | 2024-08-31 00:14:28.111000 |
|---|---|
| Maximum | 2024-09-30 23:56:49.220000 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
ended_at
Date
| Distinct | 664648 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.1 MiB |
| Minimum | 2024-09-01 00:00:14.521000 |
|---|---|
| Maximum | 2024-09-30 23:59:54.421000 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Missing 
| Distinct | 779 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 139752 |
| Missing (%) | 21.0% |
| Memory size | 44.4 MiB |
Length
| Max length | 61 |
|---|---|
| Median length | 50 |
| Mean length | 23.071792 |
| Min length | 10 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Saint Asaph St & Madison St |
|---|---|
| 2nd row | 17th & K St NW / Farragut Square |
| 3rd row | 9th & N St NW |
| 4th row | Eisenhower Ave & Mill Race Ln |
| 5th row | Eisenhower Ave & Mill Race Ln |
| Value | Count | Frequency (%) |
| 548005 | ||
| st | 432098 | 14.3% |
| nw | 293651 | 9.7% |
| ave | 158925 | 5.2% |
| ne | 66786 | 2.2% |
| 14th | 38253 | 1.3% |
| se | 32824 | 1.1% |
| n | 31711 | 1.0% |
| new | 31300 | 1.0% |
| rd | 29707 | 1.0% |
| Other values (800) | 1364236 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2510833 | ||
| t | 1055229 | 8.7% |
| e | 624914 | 5.2% |
| S | 544891 | 4.5% |
| & | 484396 | 4.0% |
| n | 463794 | 3.8% |
| a | 453678 | 3.7% |
| N | 450034 | 3.7% |
| r | 417642 | 3.4% |
| o | 410157 | 3.4% |
| Other values (60) | 4699176 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 12114744 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2510833 | ||
| t | 1055229 | 8.7% |
| e | 624914 | 5.2% |
| S | 544891 | 4.5% |
| & | 484396 | 4.0% |
| n | 463794 | 3.8% |
| a | 453678 | 3.7% |
| N | 450034 | 3.7% |
| r | 417642 | 3.4% |
| o | 410157 | 3.4% |
| Other values (60) | 4699176 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 12114744 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2510833 | ||
| t | 1055229 | 8.7% |
| e | 624914 | 5.2% |
| S | 544891 | 4.5% |
| & | 484396 | 4.0% |
| n | 463794 | 3.8% |
| a | 453678 | 3.7% |
| N | 450034 | 3.7% |
| r | 417642 | 3.4% |
| o | 410157 | 3.4% |
| Other values (60) | 4699176 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 12114744 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2510833 | ||
| t | 1055229 | 8.7% |
| e | 624914 | 5.2% |
| S | 544891 | 4.5% |
| & | 484396 | 4.0% |
| n | 463794 | 3.8% |
| a | 453678 | 3.7% |
| N | 450034 | 3.7% |
| r | 417642 | 3.4% |
| o | 410157 | 3.4% |
| Other values (60) | 4699176 |
start_station_id
Real number (ℝ)
Missing 
| Distinct | 777 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 139752 |
| Missing (%) | 21.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 31380.29 |
| Minimum | 30200 |
|---|---|
| Maximum | 33200 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.1 MiB |
Quantile statistics
| Minimum | 30200 |
|---|---|
| 5-th percentile | 31056 |
| Q1 | 31209 |
| median | 31289 |
| Q3 | 31609 |
| 95-th percentile | 31929 |
| Maximum | 33200 |
| Range | 3000 |
| Interquartile range (IQR) | 400 |
Descriptive statistics
| Standard deviation | 287.86898 |
|---|---|
| Coefficient of variation (CV) | 0.0091735602 |
| Kurtosis | 4.085314 |
| Mean | 31380.29 |
| Median Absolute Deviation (MAD) | 170 |
| Skewness | 0.85627807 |
| Sum | 1.6477445 × 1010 |
| Variance | 82868.547 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 31623 | 5467 | 0.8% |
| 31229 | 5075 | 0.8% |
| 31201 | 4546 | 0.7% |
| 31600 | 4482 | 0.7% |
| 31603 | 4439 | 0.7% |
| 31101 | 4233 | 0.6% |
| 31200 | 3703 | 0.6% |
| 31627 | 3664 | 0.6% |
| 31258 | 3605 | 0.5% |
| 31236 | 3542 | 0.5% |
| Other values (767) | 482333 | |
| (Missing) | 139752 | 21.0% |
| Value | Count | Frequency (%) |
| 30200 | 1366 | |
| 30201 | 1670 | |
| 31000 | 583 | 0.1% |
| 31002 | 710 | |
| 31003 | 585 | 0.1% |
| 31004 | 253 | < 0.1% |
| 31005 | 836 | |
| 31006 | 724 | |
| 31007 | 780 | |
| 31009 | 250 | < 0.1% |
| Value | Count | Frequency (%) |
| 33200 | 688 | |
| 32901 | 27 | < 0.1% |
| 32609 | 42 | < 0.1% |
| 32608 | 59 | < 0.1% |
| 32607 | 45 | < 0.1% |
| 32606 | 153 | < 0.1% |
| 32605 | 83 | < 0.1% |
| 32604 | 59 | < 0.1% |
| 32603 | 48 | < 0.1% |
| 32602 | 40 | < 0.1% |
end_station_name
Text
Missing 
| Distinct | 781 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 144920 |
| Missing (%) | 21.8% |
| Memory size | 44.1 MiB |
Length
| Max length | 61 |
|---|---|
| Median length | 51 |
| Mean length | 23.021399 |
| Min length | 10 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Market Square / King St & Royal St |
|---|---|
| 2nd row | 15th & W St NW |
| 3rd row | Rhode Island Ave & 39th St / Brentwood Arts Exchange |
| 4th row | Ballenger Ave & Dulaney St |
| 5th row | Ballenger Ave & Dulaney St |
| Value | Count | Frequency (%) |
| 544009 | ||
| st | 431537 | 14.4% |
| nw | 289918 | 9.7% |
| ave | 158796 | 5.3% |
| ne | 66782 | 2.2% |
| 14th | 36576 | 1.2% |
| se | 33543 | 1.1% |
| new | 31631 | 1.1% |
| sw | 30171 | 1.0% |
| m | 30001 | 1.0% |
| Other values (802) | 1349207 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2490514 | ||
| t | 1048159 | 8.8% |
| e | 617753 | 5.2% |
| S | 545507 | 4.6% |
| & | 480613 | 4.0% |
| n | 457158 | 3.8% |
| a | 446153 | 3.7% |
| N | 444714 | 3.7% |
| r | 410484 | 3.4% |
| o | 400604 | 3.3% |
| Other values (60) | 4627650 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 11969309 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2490514 | ||
| t | 1048159 | 8.8% |
| e | 617753 | 5.2% |
| S | 545507 | 4.6% |
| & | 480613 | 4.0% |
| n | 457158 | 3.8% |
| a | 446153 | 3.7% |
| N | 444714 | 3.7% |
| r | 410484 | 3.4% |
| o | 400604 | 3.3% |
| Other values (60) | 4627650 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 11969309 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2490514 | ||
| t | 1048159 | 8.8% |
| e | 617753 | 5.2% |
| S | 545507 | 4.6% |
| & | 480613 | 4.0% |
| n | 457158 | 3.8% |
| a | 446153 | 3.7% |
| N | 444714 | 3.7% |
| r | 410484 | 3.4% |
| o | 400604 | 3.3% |
| Other values (60) | 4627650 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 11969309 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2490514 | ||
| t | 1048159 | 8.8% |
| e | 617753 | 5.2% |
| S | 545507 | 4.6% |
| & | 480613 | 4.0% |
| n | 457158 | 3.8% |
| a | 446153 | 3.7% |
| N | 444714 | 3.7% |
| r | 410484 | 3.4% |
| o | 400604 | 3.3% |
| Other values (60) | 4627650 |
end_station_id
Real number (ℝ)
Missing 
| Distinct | 778 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 145015 |
| Missing (%) | 21.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 31381.767 |
| Minimum | 30200 |
|---|---|
| Maximum | 33200 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.1 MiB |
Quantile statistics
| Minimum | 30200 |
|---|---|
| 5-th percentile | 31060 |
| Q1 | 31212 |
| median | 31289 |
| Q3 | 31611 |
| 95-th percentile | 31928 |
| Maximum | 33200 |
| Range | 3000 |
| Interquartile range (IQR) | 399 |
Descriptive statistics
| Standard deviation | 288.86454 |
|---|---|
| Coefficient of variation (CV) | 0.0092048525 |
| Kurtosis | 4.2357769 |
| Mean | 31381.767 |
| Median Absolute Deviation (MAD) | 170 |
| Skewness | 0.81349061 |
| Sum | 1.6313059 × 1010 |
| Variance | 83442.722 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 31623 | 5439 | 0.8% |
| 31229 | 4998 | 0.8% |
| 31201 | 4557 | 0.7% |
| 31600 | 4556 | 0.7% |
| 31603 | 4460 | 0.7% |
| 31101 | 4169 | 0.6% |
| 31627 | 3723 | 0.6% |
| 31200 | 3720 | 0.6% |
| 31236 | 3582 | 0.5% |
| 31613 | 3429 | 0.5% |
| Other values (768) | 477193 | |
| (Missing) | 145015 | 21.8% |
| Value | Count | Frequency (%) |
| 30200 | 1609 | |
| 30201 | 1709 | |
| 31000 | 608 | 0.1% |
| 31002 | 712 | |
| 31003 | 582 | 0.1% |
| 31004 | 253 | < 0.1% |
| 31005 | 830 | |
| 31006 | 732 | |
| 31007 | 771 | |
| 31009 | 256 | < 0.1% |
| Value | Count | Frequency (%) |
| 33200 | 702 | |
| 32901 | 80 | < 0.1% |
| 32609 | 38 | < 0.1% |
| 32608 | 67 | < 0.1% |
| 32607 | 52 | < 0.1% |
| 32606 | 129 | < 0.1% |
| 32605 | 80 | < 0.1% |
| 32604 | 62 | < 0.1% |
| 32603 | 58 | < 0.1% |
| 32602 | 44 | < 0.1% |
start_lat
Real number (ℝ)
High correlation 
| Distinct | 34881 |
|---|---|
| Distinct (%) | 5.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 38.906499 |
| Minimum | 38.74 |
|---|---|
| Maximum | 39.13 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.1 MiB |
Quantile statistics
| Minimum | 38.74 |
|---|---|
| 5-th percentile | 38.862841 |
| Q1 | 38.89245 |
| median | 38.905578 |
| Q3 | 38.92 |
| 95-th percentile | 38.953691 |
| Maximum | 39.13 |
| Range | 0.39 |
| Interquartile range (IQR) | 0.027549906 |
Descriptive statistics
| Standard deviation | 0.029197204 |
|---|---|
| Coefficient of variation (CV) | 0.00075044543 |
| Kurtosis | 5.7108485 |
| Mean | 38.906499 |
| Median Absolute Deviation (MAD) | 0.0144215 |
| Skewness | 0.38571918 |
| Sum | 25866636 |
| Variance | 0.00085247674 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 38.9 | 20983 | 3.2% |
| 38.91 | 20433 | 3.1% |
| 38.92 | 18416 | 2.8% |
| 38.93 | 15592 | 2.3% |
| 38.88 | 9324 | 1.4% |
| 38.94 | 8642 | 1.3% |
| 38.89 | 8151 | 1.2% |
| 38.95 | 7990 | 1.2% |
| 38.96 | 7254 | 1.1% |
| 38.89696 | 5223 | 0.8% |
| Other values (34871) | 542833 |
| Value | Count | Frequency (%) |
| 38.74 | 13 | < 0.1% |
| 38.76 | 29 | |
| 38.76552765 | 1 | < 0.1% |
| 38.766844 | 26 | < 0.1% |
| 38.76687503 | 1 | < 0.1% |
| 38.76687562 | 1 | < 0.1% |
| 38.76688898 | 1 | < 0.1% |
| 38.76691317 | 1 | < 0.1% |
| 38.766946 | 65 | |
| 38.76843 | 15 | < 0.1% |
| Value | Count | Frequency (%) |
| 39.13 | 17 | < 0.1% |
| 39.12582811 | 26 | |
| 39.123513 | 14 | < 0.1% |
| 39.12333798 | 1 | < 0.1% |
| 39.12333 | 23 | < 0.1% |
| 39.121327 | 35 | |
| 39.12124586 | 1 | < 0.1% |
| 39.121104 | 1 | < 0.1% |
| 39.12 | 60 | |
| 39.11988258 | 1 | < 0.1% |
start_lng
Real number (ℝ)
High correlation 
| Distinct | 35211 |
|---|---|
| Distinct (%) | 5.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -77.03277 |
| Minimum | -77.39 |
|---|---|
| Maximum | -76.825416 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 664841 |
| Negative (%) | 100.0% |
| Memory size | 5.1 MiB |
Quantile statistics
| Minimum | -77.39 |
|---|---|
| 5-th percentile | -77.091862 |
| Q1 | -77.045 |
| median | -77.03 |
| Q3 | -77.011616 |
| 95-th percentile | -76.987823 |
| Maximum | -76.825416 |
| Range | 0.56458391 |
| Interquartile range (IQR) | 0.033384 |
Descriptive statistics
| Standard deviation | 0.037667961 |
|---|---|
| Coefficient of variation (CV) | -0.00048898619 |
| Kurtosis | 16.606255 |
| Mean | -77.03277 |
| Median Absolute Deviation (MAD) | 0.016912611 |
| Skewness | -2.4745639 |
| Sum | -51214544 |
| Variance | 0.0014188753 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -77.03 | 28869 | 4.3% |
| -77.02 | 18417 | 2.8% |
| -77.04 | 16154 | 2.4% |
| -77 | 12167 | 1.8% |
| -77.01 | 10959 | 1.6% |
| -77.05 | 6794 | 1.0% |
| -76.99 | 5922 | 0.9% |
| -77.07 | 5296 | 0.8% |
| -77.00493 | 5223 | 0.8% |
| -77.06 | 4989 | 0.8% |
| Other values (35201) | 550051 |
| Value | Count | Frequency (%) |
| -77.39 | 2 | < 0.1% |
| -77.38 | 3 | < 0.1% |
| -77.37 | 43 | |
| -77.368416 | 50 | |
| -77.36837947 | 1 | < 0.1% |
| -77.36800253 | 1 | < 0.1% |
| -77.36786842 | 5 | < 0.1% |
| -77.36663961 | 1 | < 0.1% |
| -77.366499 | 29 | |
| -77.3662945 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| -76.82541609 | 1 | < 0.1% |
| -76.825535 | 21 | |
| -76.83 | 18 | < 0.1% |
| -76.8387907 | 1 | < 0.1% |
| -76.84 | 29 | |
| -76.843263 | 18 | < 0.1% |
| -76.84326744 | 1 | < 0.1% |
| -76.84326827 | 1 | < 0.1% |
| -76.844604 | 49 | |
| -76.85 | 6 | < 0.1% |
end_lat
Real number (ℝ)
High correlation 
| Distinct | 834 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 489 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 38.905888 |
| Minimum | 35.84 |
|---|---|
| Maximum | 42.99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.1 MiB |
Quantile statistics
| Minimum | 35.84 |
|---|---|
| 5-th percentile | 38.862398 |
| Q1 | 38.892275 |
| median | 38.905303 |
| Q3 | 38.919018 |
| 95-th percentile | 38.952369 |
| Maximum | 42.99 |
| Range | 7.15 |
| Interquartile range (IQR) | 0.0267435 |
Descriptive statistics
| Standard deviation | 0.030324128 |
|---|---|
| Coefficient of variation (CV) | 0.00077942258 |
| Kurtosis | 953.01831 |
| Mean | 38.905888 |
| Median Absolute Deviation (MAD) | 0.013506 |
| Skewness | 2.9438704 |
| Sum | 25847204 |
| Variance | 0.00091955271 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 38.9 | 21403 | 3.2% |
| 38.91 | 21049 | 3.2% |
| 38.92 | 19028 | 2.9% |
| 38.93 | 16127 | 2.4% |
| 38.88 | 9561 | 1.4% |
| 38.94 | 8856 | 1.3% |
| 38.89 | 8562 | 1.3% |
| 38.95 | 8189 | 1.2% |
| 38.96 | 7456 | 1.1% |
| 38.89696 | 5439 | 0.8% |
| Other values (824) | 538682 |
| Value | Count | Frequency (%) |
| 35.84 | 1 | < 0.1% |
| 36.07 | 1 | < 0.1% |
| 38.63 | 1 | < 0.1% |
| 38.67 | 1 | < 0.1% |
| 38.71 | 7 | < 0.1% |
| 38.72 | 3 | < 0.1% |
| 38.73 | 2 | < 0.1% |
| 38.74 | 19 | |
| 38.75 | 3 | < 0.1% |
| 38.76 | 25 |
| Value | Count | Frequency (%) |
| 42.99 | 1 | < 0.1% |
| 42.08 | 1 | < 0.1% |
| 39.28 | 1 | < 0.1% |
| 39.25 | 1 | < 0.1% |
| 39.13 | 16 | < 0.1% |
| 39.12582811 | 25 | |
| 39.123513 | 11 | < 0.1% |
| 39.12333 | 19 | < 0.1% |
| 39.121327 | 34 | |
| 39.12 | 61 |
end_lng
Real number (ℝ)
High correlation  Skewed 
| Distinct | 855 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 489 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -77.03249 |
| Minimum | -80.18 |
|---|---|
| Maximum | -48.7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 664352 |
| Negative (%) | 99.9% |
| Memory size | 5.1 MiB |
Quantile statistics
| Minimum | -80.18 |
|---|---|
| 5-th percentile | -77.09 |
| Q1 | -77.045 |
| median | -77.03 |
| Q3 | -77.010266 |
| 95-th percentile | -76.987633 |
| Maximum | -48.7 |
| Range | 31.48 |
| Interquartile range (IQR) | 0.034734 |
Descriptive statistics
| Standard deviation | 0.051552333 |
|---|---|
| Coefficient of variation (CV) | -0.00066922844 |
| Kurtosis | 137357.31 |
| Mean | -77.03249 |
| Median Absolute Deviation (MAD) | 0.017317624 |
| Skewness | 248.61158 |
| Sum | -51176688 |
| Variance | 0.002657643 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -77.03 | 29865 | 4.5% |
| -77.02 | 18919 | 2.8% |
| -77.04 | 16687 | 2.5% |
| -77 | 12484 | 1.9% |
| -77.01 | 11333 | 1.7% |
| -77.05 | 7016 | 1.1% |
| -76.99 | 6209 | 0.9% |
| -77.07 | 5455 | 0.8% |
| -77.00493 | 5439 | 0.8% |
| -77.06 | 5059 | 0.8% |
| Other values (845) | 545886 |
| Value | Count | Frequency (%) |
| -80.18 | 1 | < 0.1% |
| -78.69 | 1 | < 0.1% |
| -78.29 | 1 | < 0.1% |
| -77.68 | 1 | < 0.1% |
| -77.49 | 1 | < 0.1% |
| -77.4 | 1 | < 0.1% |
| -77.39 | 3 | < 0.1% |
| -77.38 | 2 | < 0.1% |
| -77.37 | 44 | |
| -77.368416 | 53 |
| Value | Count | Frequency (%) |
| -48.7 | 1 | < 0.1% |
| -74.75 | 1 | < 0.1% |
| -76.51 | 1 | < 0.1% |
| -76.74 | 1 | < 0.1% |
| -76.76 | 1 | < 0.1% |
| -76.78 | 1 | < 0.1% |
| -76.825535 | 19 | |
| -76.83 | 25 | |
| -76.84 | 34 | |
| -76.843263 | 19 |
member_casual
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 39.9 MiB |
| member | |
|---|---|
| casual |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | member |
|---|---|
| 2nd row | member |
| 3rd row | casual |
| 4th row | member |
| 5th row | member |
Common Values
| Value | Count | Frequency (%) |
| member | 435233 | |
| casual | 229608 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| member | 435233 | |
| casual | 229608 |
Most occurring characters
| Value | Count | Frequency (%) |
| m | 870466 | |
| e | 870466 | |
| a | 459216 | |
| b | 435233 | |
| r | 435233 | |
| c | 229608 | 5.8% |
| s | 229608 | 5.8% |
| u | 229608 | 5.8% |
| l | 229608 | 5.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3989046 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| m | 870466 | |
| e | 870466 | |
| a | 459216 | |
| b | 435233 | |
| r | 435233 | |
| c | 229608 | 5.8% |
| s | 229608 | 5.8% |
| u | 229608 | 5.8% |
| l | 229608 | 5.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3989046 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| m | 870466 | |
| e | 870466 | |
| a | 459216 | |
| b | 435233 | |
| r | 435233 | |
| c | 229608 | 5.8% |
| s | 229608 | 5.8% |
| u | 229608 | 5.8% |
| l | 229608 | 5.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3989046 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| m | 870466 | |
| e | 870466 | |
| a | 459216 | |
| b | 435233 | |
| r | 435233 | |
| c | 229608 | 5.8% |
| s | 229608 | 5.8% |
| u | 229608 | 5.8% |
| l | 229608 | 5.8% |
Interactions
Correlations
| end_lat | end_lng | end_station_id | member_casual | rideable_type | start_lat | start_lng | start_station_id | |
|---|---|---|---|---|---|---|---|---|
| end_lat | 1.000 | -0.018 | -0.128 | 0.000 | 0.000 | 0.736 | 0.007 | -0.057 |
| end_lng | -0.018 | 1.000 | 0.453 | 0.041 | 0.044 | 0.000 | 0.732 | 0.318 |
| end_station_id | -0.128 | 0.453 | 1.000 | 0.087 | 0.046 | -0.068 | 0.312 | 0.369 |
| member_casual | 0.000 | 0.041 | 0.087 | 1.000 | 0.015 | 0.106 | 0.059 | 0.091 |
| rideable_type | 0.000 | 0.044 | 0.046 | 0.015 | 1.000 | 0.186 | 0.075 | 0.053 |
| start_lat | 0.736 | 0.000 | -0.068 | 0.106 | 0.186 | 1.000 | -0.019 | -0.115 |
| start_lng | 0.007 | 0.732 | 0.312 | 0.059 | 0.075 | -0.019 | 1.000 | 0.452 |
| start_station_id | -0.057 | 0.318 | 0.369 | 0.091 | 0.053 | -0.115 | 0.452 | 1.000 |
Missing values
Sample
| ride_id | rideable_type | started_at | ended_at | start_station_name | start_station_id | end_station_name | end_station_id | start_lat | start_lng | end_lat | end_lng | member_casual | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 9C4EFBCCA63C94D8 | classic_bike | 2024-09-03 14:02:18.985 | 2024-09-03 14:06:30.572 | Saint Asaph St & Madison St | 31097.0 | Market Square / King St & Royal St | 31042.0 | 38.812718 | -77.044097 | 38.804718 | -77.043363 | member |
| 1 | 302DB0DF65954B5A | classic_bike | 2024-09-27 17:12:06.899 | 2024-09-27 17:25:46.530 | 17th & K St NW / Farragut Square | 31233.0 | 15th & W St NW | 31125.0 | 38.902061 | -77.038322 | 38.919018 | -77.034449 | member |
| 2 | B8E500B89C4358DC | classic_bike | 2024-09-27 18:05:43.871 | 2024-09-27 18:43:56.051 | 9th & N St NW | 31336.0 | Rhode Island Ave & 39th St / Brentwood Arts Exchange | 32413.0 | 38.906622 | -77.023885 | 38.939271 | -76.955047 | casual |
| 3 | 05771DAB5118E255 | electric_bike | 2024-09-13 14:57:35.417 | 2024-09-13 15:00:11.060 | Eisenhower Ave & Mill Race Ln | 31082.0 | Ballenger Ave & Dulaney St | 31084.0 | 38.801111 | -77.068952 | 38.802677 | -77.063562 | member |
| 4 | A0BAFC8706AD756F | electric_bike | 2024-09-13 09:04:49.266 | 2024-09-13 09:06:55.120 | Eisenhower Ave & Mill Race Ln | 31082.0 | Ballenger Ave & Dulaney St | 31084.0 | 38.801111 | -77.068952 | 38.802677 | -77.063562 | member |
| 5 | 009BAE9057AF9068 | electric_bike | 2024-09-29 17:17:52.281 | 2024-09-29 17:26:10.395 | 2nd St & Massachusetts Ave NE | 31641.0 | 13th & E St SE | 31607.0 | 38.894972 | -77.003135 | 38.882915 | -76.987907 | member |
| 6 | F2841B741A0F3D93 | classic_bike | 2024-09-26 08:57:59.104 | 2024-09-26 09:01:16.587 | Eisenhower Ave & Mill Race Ln | 31082.0 | Ballenger Ave & Dulaney St | 31084.0 | 38.801111 | -77.068952 | 38.802677 | -77.063562 | member |
| 7 | 1A4241FFFA6EEEE6 | electric_bike | 2024-09-11 08:54:26.865 | 2024-09-11 08:56:20.829 | Eisenhower Ave & Mill Race Ln | 31082.0 | Ballenger Ave & Dulaney St | 31084.0 | 38.801111 | -77.068952 | 38.802677 | -77.063562 | member |
| 8 | A925A49B6E431C74 | classic_bike | 2024-09-22 17:29:37.406 | 2024-09-22 17:35:46.403 | 1st & K St NE | 31662.0 | 5th & K St NW | 31600.0 | 38.902386 | -77.005649 | 38.902734 | -77.019181 | member |
| 9 | 093FAE32F60C1E45 | electric_bike | 2024-09-23 18:18:20.233 | 2024-09-23 18:24:03.605 | Friendship Hts Metro / Wisconsin Ave & Wisconsin Cir | 32014.0 | Connecticut Ave & McKinley St NW | 31315.0 | 38.961763 | -77.085998 | 38.964544 | -77.075135 | member |
| ride_id | rideable_type | started_at | ended_at | start_station_name | start_station_id | end_station_name | end_station_id | start_lat | start_lng | end_lat | end_lng | member_casual | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 664831 | 73B124E9F7532452 | electric_bike | 2024-09-15 20:34:16.414 | 2024-09-15 20:46:22.981 | NaN | NaN | NaN | NaN | 38.85 | -76.97 | 38.85 | -76.98 | member |
| 664832 | E0732775F6664738 | electric_bike | 2024-09-15 22:14:16.104 | 2024-09-15 22:29:38.215 | NaN | NaN | NaN | NaN | 38.85 | -76.98 | 38.88 | -76.97 | member |
| 664833 | B4C52DDB80BC45C7 | electric_bike | 2024-09-15 23:51:16.742 | 2024-09-16 00:00:21.009 | NaN | NaN | NaN | NaN | 38.88 | -76.93 | 38.88 | -76.93 | member |
| 664834 | B87AC79F0732D076 | electric_bike | 2024-09-16 19:56:24.529 | 2024-09-16 20:48:01.618 | NaN | NaN | NaN | NaN | 38.85 | -76.98 | 38.85 | -76.98 | member |
| 664835 | F7FB65FE36ABFDC6 | electric_bike | 2024-09-16 10:53:53.280 | 2024-09-16 11:25:21.797 | NaN | NaN | NaN | NaN | 38.91 | -76.93 | 38.85 | -76.98 | member |
| 664836 | 4C2859F401A89BE4 | electric_bike | 2024-09-16 17:23:10.553 | 2024-09-16 18:15:01.087 | NaN | NaN | NaN | NaN | 38.88 | -77.00 | 38.90 | -76.92 | member |
| 664837 | 36C4ADE33349BF44 | electric_bike | 2024-09-16 08:59:39.257 | 2024-09-16 09:18:16.610 | NaN | NaN | NaN | NaN | 38.88 | -76.93 | 38.85 | -76.98 | member |
| 664838 | F01550D1A53887E1 | electric_bike | 2024-09-16 06:42:03.153 | 2024-09-16 06:58:53.820 | NaN | NaN | NaN | NaN | 38.93 | -77.04 | 38.90 | -77.01 | member |
| 664839 | 5D3E7F1E248D4781 | electric_bike | 2024-09-16 14:56:28.251 | 2024-09-16 14:59:51.050 | NaN | NaN | NaN | NaN | 38.93 | -77.04 | 38.94 | -77.04 | member |
| 664840 | 43524A3F14B4411D | electric_bike | 2024-09-16 15:03:28.717 | 2024-09-16 15:08:38.661 | NaN | NaN | NaN | NaN | 38.94 | -77.04 | 38.93 | -77.03 | member |